﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetTelefonoByDescription')
	BEGIN
		DROP  Procedure  GetTelefonoByDescription
	END
GO

CREATE Procedure GetTelefonoByDescription

	@descripcion nvarchar(250)

AS

BEGIN

		SELECT     *
	    FROM       Bien INNER JOIN
                   Telefono ON Bien.IdBien = Telefono.IdBien
        WHERE     (Bien.Descripcion = @descripcion)

END

GO


GRANT EXEC ON GetTelefonoByDescription TO PUBLIC

GO

